<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Managing SQL Server">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="sql-0059.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20241029">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="sql-0061">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Managing SQL Server</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="sql-0061"></a><a name="sql-0061"></a>

<h1 class="topictitle1">Managing SQL Server</h1>
<div><p>The <span id="sql-0061__en-us_topic_0000001792344090_text371620488123">OceanProtect</span> allows you to perform operations on databases, such as modifying, removing, activating, and disabling protection.</p>
<ol><li><span>Choose <span class="uicontrol" id="sql-0061__en-us_topic_0000001839142377_uicontrol114088356363"><b><span id="sql-0061__en-us_topic_0000001839142377_text1840913533616"><strong>Protection</strong></span> &gt; Databases &gt; SQL Server</b></span>.</span></li><li><span>Click the <span class="uicontrol"><b><span><strong>Instance</strong></span></b></span>, <span class="uicontrol"><b><span><strong>Availability Group</strong></span></b></span>, or <span class="uicontrol"><b><span><strong>Databases</strong></span></b></span> tab and find the target database, instance, or availability group. The following takes <span class="uicontrol"><b>Databases</b></span> as an example.</span><p><p><a href="#sql-0061__table29958188230">Table 1</a> describes the related operations.</p>

<div class="tablenoborder"><a name="sql-0061__table29958188230"></a><a name="table29958188230"></a><table cellpadding="4" cellspacing="0" summary="" id="sql-0061__table29958188230" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Operations related to database, instance, and availability group management</caption><colgroup><col style="width:14.360000000000001%"><col style="width:57.91%"><col style="width:27.73%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="14.360000000000003%" id="mcps1.3.2.2.2.2.2.4.1.1"><p>Operation</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="57.910000000000004%" id="mcps1.3.2.2.2.2.2.4.1.2"><p>Description</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="27.730000000000004%" id="mcps1.3.2.2.2.2.2.4.1.3"><p>Navigation Path</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><p><span><strong>Modify Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>You can modify a protection plan to associate another SLA with a database or modify a user-defined script. After the modification, the next backup will be executed based on the new protection plan.</p>
<p><strong>Note</strong></p>
<ul><li>The modification does not affect the protection job that is being executed. The modified protection plan will take effect in the next protection period.</li><li>If the SLA associated with a resource changes, you are advised to modify the current SLA by choosing <span class="uicontrol"><b><span id="sql-0061__en-us_topic_0000001839142377_text71111921162814"><strong>Protection</strong></span> &gt; Protection Policies &gt; SLAs</b></span>. You are advised not to associate the resource with another SLA by modifying the protection.<p>When you associate the resource with another SLA by modifying protection, the license capacity may be deducted repeatedly if the copy of the original SLA still exists.</p>
</li></ul>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><p>Choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Modify Protection</strong></span></b></span> in the row where the database is located.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><p><span><strong>Remove Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>You can remove the protection plan if the database no longer needs to be protected. After removal, the system cannot execute protection jobs for the database.</p>
<p><strong>Note</strong></p>
<ul><li>Protection cannot be removed when a protection job of the database is running.</li><li>If the SLA associated with a resource changes, you are advised to modify the current SLA by choosing <span class="uicontrol"><b><span id="sql-0061__en-us_topic_0000001839142377_text71111921162814_1"><strong>Protection</strong></span> &gt; Protection Policies &gt; SLAs</b></span>. You are advised not to associate the resource with another SLA after removing the protection.<p>When you associate the resource with another SLA after removing protection, the license capacity may be deducted repeatedly if the copy of the original SLA still exists.</p>
</li></ul>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><p>Choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Remove Protection</strong></span></b></span> in the row where the database is located.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><p><span><strong>Manual Backup</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to perform a backup immediately.</p>
<p><strong>Note</strong></p>
<p>Copies generated by manual backup are retained based on the SLA.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><p>Choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Manual Backup</strong></span></b></span> in the row where the database is located.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><p><span><strong>Activate Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to activate a disabled protection plan of a database. After the protection plan is activated, the system backs up the database based on the protection plan.</p>
<p><strong>Note</strong></p>
<p>You can perform this operation only on a database that has been associated with an SLA and is in the <span class="uicontrol"><b><span><strong>Unprotected</strong></span></b></span> state.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><p>Choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Activate Protection</strong></span></b></span> in the row where the database is located.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><p><span><strong>Disable Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>You can disable the protection plan of a database if it no longer needs periodical protection. After the protection plan is disabled, the system does not execute the automatic backup job of the database.</p>
<p><strong>Note</strong></p>
<p>Disabling protection does not affect ongoing backup jobs.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><p>Choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Disable Protection</strong></span></b></span> in the row where the database is located.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><div class="p">Adding a tag<div class="note" id="sql-0061__en-us_topic_0000001792344090_note161679211561"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="sql-0061__en-us_topic_0000001792344090_p1816719214566">Only 1.6.0 and later versions support this function.</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to quickly filter and manage resources.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><div class="p">Choose <span class="uicontrol" id="sql-0061__en-us_topic_0000001792344090_uicontrol84421111904"><b><span id="sql-0061__en-us_topic_0000001792344090_text6442710012"><strong>More</strong></span> &gt; Add Tag</b></span>.<div class="note" id="sql-0061__en-us_topic_0000001792344090_note164681316118"><span class="notetitle"> NOTE: </span><div class="notebody"><ul id="sql-0061__en-us_topic_0000001792344090_ul22969251338"><li id="sql-0061__en-us_topic_0000001792344090_li142961925139">On the displayed <strong id="sql-0061__en-us_topic_0000001792344090_b171967427617">Add Tag</strong> dialog box, you can select existing tags or click <strong id="sql-0061__en-us_topic_0000001792344090_b1711194810818">Create</strong> to create a tag.</li><li id="sql-0061__en-us_topic_0000001792344090_li135161927738">To modify or delete a tag, click <strong id="sql-0061__en-us_topic_0000001792344090_b17675195912164">Go to Tag Management</strong> on the <strong id="sql-0061__en-us_topic_0000001792344090_b13536183171711">Add Tag</strong> page to go to the <strong id="sql-0061__en-us_topic_0000001792344090_b1386161351713">Tag Management</strong> page.</li></ul>
</div></div>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.360000000000003%" headers="mcps1.3.2.2.2.2.2.4.1.1 "><div class="p">Removing a tag<div class="note" id="sql-0061__en-us_topic_0000001792344090_note4957114117575"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="sql-0061__en-us_topic_0000001792344090_en-us_topic_0000001792344090_p1816719214566">Only 1.6.0 and later versions support this function.</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="57.910000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to remove the tag of a resource when it is no longer needed.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.2.2.2.2.2.4.1.3 "><p>Choose <span class="uicontrol" id="sql-0061__en-us_topic_0000001792344090_uicontrol4993205113111"><b><span id="sql-0061__en-us_topic_0000001792344090_text6993751201118"><strong>More</strong></span> &gt; Remove Tag</b></span>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</p></li></ol>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="sql-0059.html">SQL Server Database Environment</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>